SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 19992: Calculated members created at the ALL level of an OLAP dimension are rendered incorrectly

DetailsAboutRate It
Calculated members created at the ALL level of an OLAP dimension might
be rendered incorrectly in SAS Information Map Studio, SAS Web Report
Studio and SAS Web OLAP Viewer for Java. This problem does not generate
any errors. It is only evident when you are viewing the report. An
example of a calulated member in PROC OLAP that will generate this
rendering problem is as follows:

   DEFINE
      MEMBER "[Example].[DimAge].[All DimAge].[Age 12 to 13]" AS
      "AGGREGATE({[DimAge].[All DimAge].[12],
       [DimAge].[AllDimAge].[13]})";

A workaround is to create the member at a level other than the ALL
level. For example,

   DEFINE
      MEMBER '[Example].[DimAge].[Age 12 to 13]' AS
      'AGGREGATE({[DimAge].[All DimAge].[12],
       [DimAge].[AllDimAge].[13]}),
       FORMAT_STRING="BEST20.2"';


Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Information Map StudioMicrosoft Windows Server 2003 Enterprise Edition3.14.319.1 TS1M3 SP49.3 TS1M0
Microsoft Windows Server 2003 Datacenter Edition3.14.319.1 TS1M3 SP49.3 TS1M0
Microsoft Windows 2000 Advanced Server3.19.1 TS1M3 SP4
Microsoft Windows 2000 Datacenter Server3.19.1 TS1M3 SP4
Microsoft Windows 2000 Server3.19.1 TS1M3 SP4
Microsoft Windows 2000 Professional3.19.1 TS1M3 SP4
Microsoft Windows NT Workstation3.19.1 TS1M3 SP4
Microsoft Windows Server 2003 Standard Edition3.14.319.1 TS1M3 SP49.3 TS1M0
Microsoft Windows XP Professional3.14.319.1 TS1M3 SP49.3 TS1M0
Windows Vista3.14.319.1 TS1M3 SP49.3 TS1M0
Windows Vista for x643.14.319.1 TS1M3 SP49.3 TS1M0
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.